To deploy IngredMgmt

Copy directory (ingredMgt) as is to disk from Google Drive.
Add an 'application' to the IIS default site.
Check the connection string in the web config.
Set the app pool to 'Classic .NET AppPool'
Site uses an early AJAX technique called "Ajax.NET"
Docs are Here
You also have to turn off virtually all security settings on the browser.


To Deploy Recnut Admin

Create an app pool with no managed code and classic pipeline
Create a application under default
Make sure ASP is allowed in the server properties in program and features - windows features
You can see asp errors by setting 'Send errors to Browser to True in ASP properties at server level
change address in :
var win = window.open("http://216.198.198.126/recnutadmin/stdEdit.asp?recid=" + document.getElementById("ingId").value + "&tblid=21")

To update the ingredient counts in the mobile app run this query

update foodLevel1 set i_ingsNextLevel = (select COUNT(i_lev1_fk) from foodLevel2 where i_foolev1_id = i_lev1_fk )
update foodLevel2 set i_ingsNextLevel = (select COUNT(i_lev2_fk) from foodLevel3 where i_foolev2_id = i_lev2_fk )
update foodMasterGroup set i_ingsNextLevel = (select COUNT(i_foolev1_id) from foodLevel1 where i_foomasgrp_fk = i_foomasgro_id )
 

To update the number of times that the ingredient is used

sp_upd_friendlyUsedCount

code

code